{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Computation","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,2],[10,0,10,2],[14,0,14,2],[0,0,0,2],[1,0,1,2],[12,0,12,2],[13,0,13,2],[11,0,11,2]]}
["National Housing Bank"]
["Calculator for Rural Household Interest Subsidy Scheme (RHISS)"]
["First Disbursement Date","2017-01-01","Date should be on or after 01-jan-2017"]
["Current Disbursement Date (for which subsidy claimed)","2017-01-01","Date should  be on or after first disbursement date"]
["Loan Tenure (in months)",240,"Numeric Integer only"]
["Amount Disbursed before this installment (in Rs.)",0,"Numeric Integer only"]
["Current Disbursement Installment (in Rs.)",200000,"Numeric Integer only"]
["Applied Interest Rate for subsidy calculation (in % p.a)",3,"NO input data"]
["Subsidy Amount",38359.275482959165]
[]
["Assumptions:"]
["a. Interest for calculation of subsidy is arrived at by applying interest @ 3% p.a. on the disbursed amount and on monthly rest basis"]
["b. Subsidy is calculated for a maximum tenure of 240 months (20 years) from first disbursement."]
["c. NPV is calculated at the discount rate of 9% and on monthly rest basis."]
["d. Interest Subsidy is calculated for eligible disbursement amount  upto first Rs 2 lakh of loan amount."]
["e. Paisa is rounded off to the nearest rupee in the total"]

{"sheet":"Computation","index":1,"n_rows":243,"n_cols":14,"rows_kept":243,"cut":false,"hidden":false,"merged":[]}
["Parameters",null,"Loan Amount",{"$f":"IF((Data!B6+Data!B7)>200000,200000-Data!B6,Data!B7)","v":200000},"Loan Tenure",{"$f":"IF(Data!B5>240,240,Data!B5)","v":240},"Cur Inst Tenure",{"$f":"IF(Data!B4=\"\",0, F1-((YEAR(Data!B4)-YEAR(Data!B3))*12+MONTH(Data!B4)-MONTH(Data!B3)))","v":240},"Int Rate",{"$f":"IF(Data!B8>3,3,Data!B8)","v":3},"r ",{"$f":"J1/1200","v":2.5000000000000001E-3},"(1+r)^n-1",{"$f":"((1+L1)^H1)-1","v":0.82075499531646523}]
[null,"BALANCE","EMI","INTEREST","principal repayment","CL BALANCE","NPV(By Formula)",null,null,"EMI",{"$f":"IF($N$1=0,0,($D$1*$L$1)*((1+$L$1)^$H$1)/$N$1)","v":1109.1951957078384}]
[1,{"$f":"D1","v":200000},{"$f":"K2","v":1109.1951957078384},{"$f":"B3*$J$1/(1200)","v":500},{"$f":"C3-D3","v":609.19519570783837},{"$f":"B3-E3","v":199390.80480429216},{"$f":"D3/POWER(1+9/1200,A3)","v":496.27791563275429}]
[{"$f":"A3+1","v":2},{"$f":"IF(F3>0,F3,0)","v":199390.80480429216},{"$f":"IF(B4>0,C3,0)","v":1109.1951957078384},{"$f":"B4*$J$1/1200","v":498.47701201073039},{"$f":"C4-D4","v":610.71818369710797},{"$f":"B4-E4","v":198780.08662059504},{"$f":"D4/POWER(1+9/1200,A4)","v":491.08314146209165}]
[{"$f":"A4+1","v":3},{"$f":"IF(F4>0,F4,0)","v":198780.08662059504},{"$f":"IF(B5>0,C4,0)","v":1109.1951957078384},{"$f":"B5*$J$1/1200","v":496.95021655148759},612.24497915635084,198167.84164143869,485.93448420896493]
[4,198167.84164143869,1109.1951957078384,495.41960410359673,613.77559160424164,197554.06604983445,480.83156361769983]
[5,197554.06604983445,1109.1951957078384,493.88516512458608,615.31003058325223,196938.75601925119,475.77400244670179]
[6,196938.75601925119,1109.1951957078384,492.34689004812799,616.84830565971038,196321.90771359147,470.76142644510838]
[7,196321.90771359147,1109.1951957078384,490.80476928397866,618.39042642385971,195703.5172871676,465.79346432962058]
[8,195703.5172871676,1109.1951957078384,489.25879321791899,619.93640248991937,195083.58088467768,460.86974776151044]
[9,195083.58088467768,1109.1951957078384,487.70895221169417,621.4862434961442,194462.09464118152,455.98991132380417]
[10,194462.09464118152,1109.1951957078384,486.15523660295383,623.03995910488447,193839.05468207665,451.15359249864031,"Total NPV as per Manual Formula",{"$f":"SUM(G3:G242)","v":38359.275482959165}]
[11,193839.05468207665,1109.1951957078384,484.59763670519158,624.59755900264679,193214.45712307401,446.36043164480043,"NPV by Excel Formula",{"$f":"NPV(9/1200,D3:D242)","v":38359.275482959245}]
[12,193214.45712307401,1109.1951957078384,483.03614280768505,626.15905290015326,192588.29807017386,441.61007197541164]
[13,192588.29807017386,1109.1951957078384,481.47074517543467,627.72445053240369,191960.57361964145,436.9021595358189]
[14,191960.57361964145,1109.1951957078384,479.90143404910361,629.29376165873475,191331.27985798271,432.23634318162721]
[15,191331.27985798271,1109.1951957078384,478.32819964495684,630.86699606288153,190700.41286191982,427.6122745569117]
[16,190700.41286191982,1109.1951957078384,476.75103215479953,632.44416355303883,190067.96869836678,423.02960807259308]
[17,190067.96869836678,1109.1951957078384,475.16992174591695,634.02527396192136,189433.94342440486,418.48800088497944]
[18,189433.94342440486,1109.1951957078384,473.5848585610122,635.61033714682617,188798.33308725804,413.98711287447179]
[19,188798.33308725804,1109.1951957078384,471.9958327181451,637.19936298969333,188161.13372426835,409.52660662443225]
[20,188161.13372426835,1109.1951957078384,470.40283431067093,638.7923613971675,187522.34136287117,405.10614740021379]
[21,187522.34136287117,1109.1951957078384,468.80585340717789,640.38934230066047,186881.95202057052,400.72540312835048]
[22,186881.95202057052,1109.1951957078384,467.2048800514263,641.99031565641212,186239.96170491411,396.38404437590674]
[23,186239.96170491411,1109.1951957078384,465.59990426228529,643.59529144555313,185596.36641346855,392.08174432998425]
[24,185596.36641346855,1109.1951957078384,463.99091603367145,645.20427967416686,184951.16213379439,387.81817877738592]
[25,184951.16213379439,1109.1951957078384,462.377905334486,646.81729037335231,184304.34484342104,383.59302608443505]
[26,184304.34484342104,1109.1951957078384,460.76086210855266,648.43433359928576,183655.91050982176,379.40596717694956]
[27,183655.91050982176,1109.1951957078384,459.13977627455444,650.05541943328399,183005.85509038848,375.25668552036808]
[28,183005.85509038848,1109.1951957078384,457.51463772597123,651.6805579818672,182354.17453240661,371.14486710002933]
[29,182354.17453240661,1109.1951957078384,455.88543633101654,653.30975937682183,181700.86477302978,367.07020040160177]
[30,181700.86477302978,1109.1951957078384,454.25216193257444,654.94303377526398,181045.92173925453,363.03237639166258]
[31,181045.92173925453,1109.1951957078384,452.61480434813632,656.58039135970205,180389.34134789484,359.03108849842653]
[32,180389.34134789484,1109.1951957078384,450.97335336973708,658.22184233810128,179731.11950555674,355.06603259262056]
[33,179731.11950555674,1109.1951957078384,449.32779876389179,659.86739694394657,179071.2521086128,351.1369069685058]
[34,179071.2521086128,1109.1951957078384,447.67813027153198,661.51706543630644,178409.73504317648,347.24341232504503]
[35,178409.73504317648,1109.1951957078384,446.02433760794122,663.17085809989715,177746.56418507657,343.38525174721343]
[36,177746.56418507657,1109.1951957078384,444.36641046269136,664.82878524514695,177081.73539983141,339.56213068745274]
[37,177081.73539983141,1109.1951957078384,442.70433849957851,666.49085720825985,176415.24454262314,335.77375694726754]
[38,176415.24454262314,1109.1951957078384,441.03811135655781,668.15708435128056,175747.08745827185,332.0198406589621]
[39,175747.08745827185,1109.1951957078384,439.36771864567959,669.82747706215878,175077.2599812097,328.30009426751741]
[40,175077.2599812097,1109.1951957078384,437.69314995302432,671.50204575481405,174405.75793545489,324.61423251260658]
[41,174405.75793545489,1109.1951957078384,436.01439483863726,673.18080086920111,173732.57713458571,320.96197241074776]
[42,173732.57713458571,1109.1951957078384,434.33144283646425,674.86375287137412,173057.71338171433,317.34303323759463]
[43,173057.71338171433,1109.1951957078384,432.64428345428587,676.5509122535525,172381.16246946077,313.7571365103617]
[44,172381.16246946077,1109.1951957078384,430.95290617365197,678.2422895341864,171702.92017992659,310.204005970384]
[45,171702.92017992659,1109.1951957078384,429.25730044981651,679.93789525802185,171022.98228466857,306.68336756581141]
[46,171022.98228466857,1109.1951957078384,427.55745571167142,681.63773999616694,170341.34454467241,303.19494943443408]
[47,170341.34454467241,1109.1951957078384,425.85336136168104,683.34183434615738,169658.00271032625,299.73848188664107]
[48,169658.00271032625,1109.1951957078384,424.14500677581566,685.05018893202271,168972.95252139424,296.31369738850788]
[49,168972.95252139424,1109.1951957078384,422.43238130348561,686.76281440435275,168286.18970698988,292.92033054501462]
[50,168286.18970698988,1109.1951957078384,420.71547426747469,688.47972144036362,167597.70998554953,289.5581180833924]
[51,167597.70998554953,1109.1951957078384,418.99427496387381,690.20092074396462,166907.50906480558,286.22679883659765]
[52,166907.50906480558,1109.1951957078384,417.26877266201393,691.92642304582444,166215.58264175974,282.92611372691221]
[53,166215.58264175974,1109.1951957078384,415.53895660439935,693.65623910343902,165521.9264026563,279.65580574967015]
[54,165521.9264026563,1109.1951957078384,413.80481600664075,695.39037970119762,164826.53602295512,276.41561995710856]
[55,164826.53602295512,1109.1951957078384,412.06634005738783,697.12885565045053,164129.40716730466,273.20530344234277]
[56,164129.40716730466,1109.1951957078384,410.32351791826164,698.87167778957678,163430.53548951508,270.02460532346322]
[57,163430.53548951508,1109.1951957078384,408.57633872378773,700.61885698405058,162729.91663253104,266.87327672775604]
[58,162729.91663253104,1109.1951957078384,406.82479158132759,702.37040412651072,162027.54622840454,263.7510707760427]
[59,162027.54622840454,1109.1951957078384,405.06886557101137,704.12633013682694,161323.41989826772,260.65774256714133]
[60,161323.41989826772,1109.1951957078384,403.30854974566932,705.88664596216904,160617.53325230555,257.59304916244582]
[61,160617.53325230555,1109.1951957078384,401.54383313076386,707.65136257707445,159909.88188972848,254.55674957062445]
[62,159909.88188972848,1109.1951957078384,399.77470472432123,709.42049098351708,159200.46139874496,251.54860473243451]
[63,159200.46139874496,1109.1951957078384,398.0011534968624,711.19404221097602,158489.26735653399,248.56837750565481]
[64,158489.26735653399,1109.1951957078384,396.22316839133498,712.97202731650339,157776.29532921748,245.6158326501328]
[65,157776.29532921748,1109.1951957078384,394.44073832304372,714.7544573847947,157061.54087183269,242.69073681294617]
[66,157061.54087183269,1109.1951957078384,392.65385217958175,{"$f":"C68-D68","v":716.54134352825668},{"$f":"B68-E68","v":156344.99952830444},{"$f":"D68/POWER(1+9/1200,A68)","v":239.79285851367939}]
[{"$f":"A68+1","v":67},{"$f":"IF(F68>0,F68,0)","v":156344.99952830444},{"$f":"IF(B69>0,C68,0)","v":1109.1951957078384},{"$f":"B69*$J$1/1200","v":390.86249882076112},718.33269688707719,155626.66683141736,236.92196812981229]
[68,155626.66683141736,1109.1951957078384,389.06666707854339,720.12852862929503,154906.53830278807,234.07783788222096]
[69,154906.53830278807,1109.1951957078384,387.26634575697022,721.9288499508682,154184.60945283721,231.26024182079004]
[70,154184.60945283721,1109.1951957078384,385.46152363209302,723.73367207574529,153460.87578076145,228.4689558101351]
[71,153460.87578076145,1109.1951957078384,383.65218945190361,725.54300625593476,152735.33277450551,225.7037575154352]
[72,152735.33277450551,1109.1951957078384,381.83833193626378,727.35686377157458,152007.97591073395,222.96442638837362]
[73,152007.97591073395,1109.1951957078384,380.01993977683492,729.17525593100345,151278.80065480294,220.25074365318653]
[74,151278.80065480294,1109.1951957078384,378.19700163700736,730.998194070831,150547.80246073211,217.56249229281889]
[75,150547.80246073211,1109.1951957078384,376.36950615183031,732.825689556008,149814.97677117609,214.89945703518711]
[76,149814.97677117609,1109.1951957078384,374.53744192794022,734.65775377989814,149080.31901739619,212.26142433954615]
[77,149080.31901739619,1109.1951957078384,372.70079754349047,736.4943981643479,148343.82461923183,209.64818238296223]
[78,148343.82461923183,1109.1951957078384,370.85956154807957,738.3356341597588,147605.48898507206,207.05952104688865]
[79,147605.48898507206,1109.1951957078384,369.01372246268016,740.18147324515826,146865.30751182692,204.49523190384565]
[80,146865.30751182692,1109.1951957078384,367.16326877956732,742.0319269282711,146123.27558489866,201.95510820420145]
[81,146123.27558489866,1109.1951957078384,365.30818896224662,743.88700674559175,145379.38857815307,199.43894486305558]
[82,145379.38857815307,1109.1951957078384,363.44847144538267,745.7467242624557,144633.64185389061,196.94653844722285]
[83,144633.64185389061,1109.1951957078384,361.58410463472654,747.61109107311177,143886.03076281751,194.47768716231715]
[84,143886.03076281751,1109.1951957078384,359.71507690704379,749.48011880079457,143136.55064401671,192.03219083993446]
[85,143136.55064401671,1109.1951957078384,357.84137661004178,751.35381909779653,142385.19682491891,189.60985092493453]
[86,142385.19682491891,1109.1951957078384,355.96299206229725,753.23220364554118,141631.96462127336,187.21047046282004]
[87,141631.96462127336,1109.1951957078384,354.07991155318342,755.115284154655,140876.84933711871,184.83385408721327]
[88,140876.84933711871,1109.1951957078384,352.19212334279678,757.00307236504159,140119.84626475367,182.47980800742795]
[89,140119.84626475367,1109.1951957078384,350.29961566188416,758.89558004595415,139360.9506847077,180.14813999613784]
[90,139360.9506847077,1109.1951957078384,348.40237671176925,760.79281899606917,138600.15786571163,177.83865937713944]
[91,138600.15786571163,1109.1951957078384,346.5003946642791,762.69480104355921,137837.46306466806,175.55117701320887]
[92,137837.46306466806,1109.1951957078384,344.59365766167014,764.60153804616823,137072.86152662188,173.28550529405197]
[93,137072.86152662188,1109.1951957078384,342.68215381655472,766.51304189128359,136306.34848473061,171.04145812434757]
[94,136306.34848473061,1109.1951957078384,340.76587121182655,768.42932449601176,135537.9191602346,168.81885091188192]
[95,135537.9191602346,1109.1951957078384,338.84479790058646,770.35039780725197,134767.56876242734,166.61750055577502]
[96,134767.56876242734,1109.1951957078384,336.91892190606836,772.27627380177,133995.29248862556,164.43722543479734]
[97,133995.29248862556,1109.1951957078384,334.98823122156392,774.2069644862745,133221.08552413929,162.27784539577581]
[98,133221.08552413929,1109.1951957078384,333.05271381034822,776.14248189749014,132444.94304224179,160.13918174209019]
[99,132444.94304224179,1109.1951957078384,331.11235760560447,778.08283810223384,131666.86020413955,158.02105722225681]
[100,131666.86020413955,1109.1951957078384,329.16715051034885,780.02804519748952,130886.83215894207,155.92329601860055]
[101,130886.83215894207,1109.1951957078384,327.21708039735518,781.97811531048319,130104.85404363158,153.84572373601418]
[102,130104.85404363158,1109.1951957078384,325.26213510907894,783.93306059875943,129320.92098303282,151.78816739080378]
[103,129320.92098303282,1109.1951957078384,323.30230245758207,785.89289325025629,128535.02808978256,149.75045539962048]
[104,128535.02808978256,1109.1951957078384,321.33757022445639,787.85762548338198,127747.17046429918,147.73241756847685]
[105,127747.17046429918,1109.1951957078384,319.36792616074797,789.8272695470904,126957.34319475209,145.7338850818484]
[106,126957.34319475209,1109.1951957078384,317.39335798688018,791.80183772095825,126165.54135703114,143.75469049185824]
[107,126165.54135703114,1109.1951957078384,315.41385339257783,793.78134231526053,125371.76001471588,141.79466770754607]
[108,125371.76001471588,1109.1951957078384,313.42940003678967,795.76579567104864,124575.99421904483,139.8536519842184]
[109,124575.99421904483,1109.1951957078384,311.43998554761214,797.75521016022617,123778.23900888462,137.93147991288211]
[110,123778.23900888462,1109.1951957078384,309.44559752221153,799.74959818562684,122978.48941069898,136.02798940975831]
[111,122978.48941069898,1109.1951957078384,307.44622352674742,801.74897218109095,122176.7404385179,134.14301970587792]
[112,122176.7404385179,1109.1951957078384,305.44185109629473,803.75334461154364,121372.98709390635,132.2764113367565]
[113,121372.98709390635,1109.1951957078384,303.43246773476585,805.76272797307251,120567.22436593329,130.42800613214897]
[114,120567.22436593329,1109.1951957078384,301.41806091483323,807.77713479300519,119759.44723114028,128.59764720588356]
[115,119759.44723114028,1109.1951957078384,299.3986180778507,809.79657762998772,118949.6506535103,126.78517894577355]
[116,118949.6506535103,1109.1951957078384,297.37412663377575,811.82106907406262,118137.82958443623,124.99044700360702]
[117,118137.82958443623,1109.1951957078384,295.34457396109053,813.85062174674783,117323.97896268948,123.21329828521375]
[118,117323.97896268948,1109.1951957078384,293.30994740672372,815.88524830111464,116508.09371438836,121.45358094060855]
[119,116508.09371438836,1109.1951957078384,291.2702342859709,817.92496142186747,115690.16875296649,119.71114435421046]
[120,115690.16875296649,1109.1951957078384,289.22542188241624,819.96977382542218,114870.19897914107,117.98583913513782]
[121,114870.19897914107,1109.1951957078384,287.17549744785271,822.01969825998572,114048.17928088109,116.27751710757735]
[122,114048.17928088109,1109.1951957078384,285.12044820220274,824.07474750563563,113224.10453337544,114.5860313012283]
[123,113224.10453337544,1109.1951957078384,283.06026133343858,826.13493437439979,112397.96959900105,112.91123594181965]
[124,112397.96959900105,1109.1951957078384,280.99492399750261,828.20027171033576,111569.76932729072,111.25298644170086]
[125,111569.76932729072,1109.1951957078384,278.92442331822679,830.27077238961158,110739.4985549011,109.6111393905048]
[126,110739.4985549011,1109.1951957078384,276.84874638725273,832.34644932058563,109907.15210558052,107.98555254588288]
[127,109907.15210558052,1109.1951957078384,274.76788026395127,834.4273154438871,109072.72479013664,106.37608482431185]
[128,109072.72479013664,1109.1951957078384,272.68181197534159,836.51338373249678,108236.21140640414,104.78259629197112]
[129,108236.21140640414,1109.1951957078384,270.59052851601035,838.60466719182796,107397.60673921231,103.20494815569042]
[130,107397.60673921231,1109.1951957078384,268.49401684803075,{"$f":"C132-D132","v":840.70117885980767},{"$f":"B132-E132","v":106556.9055603525},{"$f":"D132/POWER(1+9/1200,A132)","v":101.64300275396781}]
[{"$f":"A132+1","v":131},{"$f":"IF(F132>0,F132,0)","v":106556.9055603525},{"$f":"IF(B133>0,C132,0)","v":1109.1951957078384},{"$f":"B133*$J$1/1200","v":266.39226390088129},842.80293180695708,105714.10262854554,100.09662354805668]
[132,105714.10262854554,1109.1951957078384,264.28525657136385,844.90993913647458,104869.19268940907,98.565675113121188]
[133,104869.19268940907,1109.1951957078384,262.1729817235227,847.02221398431561,104022.17047542476,97.050023129460627]
[134,104022.17047542476,1109.1951957078384,260.05542618856191,849.13976951927646,103173.03070590549,95.549534373800952]
[135,103173.03070590549,1109.1951957078384,257.93257676476372,851.26261894307459,102321.76808696242,94.064076710653865]
[136,102321.76808696242,1109.1951957078384,255.80442021740606,853.39077549043236,101468.37731147198,92.593519083742464]
[137,101468.37731147198,1109.1951957078384,253.67094327867997,855.52425242915842,100612.85305904283,91.137731507493029]
[138,100612.85305904283,1109.1951957078384,251.53213264760706,857.66306306023125,99755.189995982597,89.696585058592689]
[139,99755.189995982597,1109.1951957078384,249.38797498995652,859.80722071788182,98895.382775264719,88.269951867612122]
[140,98895.382775264719,1109.1951957078384,247.23845693816179,861.95673876967658,98033.426036495046,86.857705110692905]
[141,98033.426036495046,1109.1951957078384,245.08356509123763,864.11163061660068,97169.314405878438,85.459719001299334]
[142,97169.314405878438,1109.1951957078384,242.92328601469612,866.27190969314222,96303.042496185299,84.07586878203351]
[143,96303.042496185299,1109.1951957078384,240.75760624046325,868.43758946737512,95434.604906717926,82.706030716514178]
[144,95434.604906717926,1109.1951957078384,238.58651226679484,870.60868344104347,94563.996223276888,81.350082081317908]
[145,94563.996223276888,1109.1951957078384,236.40999055819222,872.78520514964612,93691.211018127244,80.007901157982516]
[146,93691.211018127244,1109.1951957078384,234.2280275453181,874.96716816252024,92816.243849964725,78.679367225072724]
[147,92816.243849964725,1109.1951957078384,232.04060962491184,877.15458608292647,91939.089263881804,77.364360550306714]
[148,91939.089263881804,1109.1951957078384,229.84772315970451,879.34747254813385,91059.741791333669,76.062762382743472]
[149,91059.741791333669,1109.1951957078384,227.64935447833417,881.54584122950416,90178.195950104171,74.774454945031067]
[150,90178.195950104171,1109.1951957078384,225.44548987526045,883.74970583257789,89294.446244271589,73.499321425714129]
[151,89294.446244271589,1109.1951957078384,223.23611561067898,885.95908009715936,88408.487164174425,72.237245971601439]
[152,88408.487164174425,1109.1951957078384,221.02121791043604,888.17397779740236,87520.313186377025,70.988113680192043]
[153,87520.313186377025,1109.1951957078384,218.80078296594255,890.39441274189585,86629.91877363513,69.751810592160311]
[154,86629.91877363513,1109.1951957078384,216.57479693408783,892.62039877375059,85737.298374861377,68.528223683898801]
[155,85737.298374861377,1109.1951957078384,214.34324593715345,894.85194977068488,84842.446425090689,67.317240860119043]
[156,84842.446425090689,1109.1951957078384,212.10611606272673,897.08907964511161,83945.357345445576,66.118750946509337]
[157,83945.357345445576,1109.1951957078384,209.86339336361394,899.33180234422446,83046.02554310135,64.932643682449637]
[158,83046.02554310135,1109.1951957078384,207.61506385775337,901.58013185008497,82144.445411251261,63.758809713782412]
[159,82144.445411251261,1109.1951957078384,205.36111352812813,903.83408217971021,81240.611329071544,62.597140585639856]
[160,81240.611329071544,1109.1951957078384,203.10152832267886,906.09366738515951,80334.51766168639,61.447528735326294]
[161,80334.51766168639,1109.1951957078384,200.83629415421595,908.35890155362245,79426.158760132763,60.309867485255729]
[162,79426.158760132763,1109.1951957078384,198.5653969003319,910.6297988075064,78515.528961325253,59.184051035944236]
[163,78515.528961325253,1109.1951957078384,196.28882240331313,912.90637330452523,77602.622588020735,58.06997445905639]
[164,77602.622588020735,1109.1951957078384,194.00655647005183,915.18863923778656,76687.433948782942,56.967533690505604]
[165,76687.433948782942,1109.1951957078384,191.71858487195735,917.47661083588105,75769.957337947068,55.876625523607899]
[166,75769.957337947068,1109.1951957078384,189.42489334486766,919.77030236297071,74850.187035584095,54.797147602288675]
[167,74850.187035584095,1109.1951957078384,187.12546758896025,922.06972811887817,73928.117307465218,53.728998414342087]
[168,73928.117307465218,1109.1951957078384,184.82029326866302,924.37490243917534,73003.742405026045,52.672077284742628]
[169,73003.742405026045,1109.1951957078384,182.50935601256512,926.68583969527322,72077.056565330771,51.626284369008523]
[170,72077.056565330771,1109.1951957078384,180.19264141332692,929.00255429451147,71148.054011036264,50.591520646616495]
[171,71148.054011036264,1109.1951957078384,177.87013502759066,931.3250606802477,70216.728950356017,49.567687914467669]
[172,70216.728950356017,1109.1951957078384,175.54182237589004,933.65337333194839,69283.075577024065,48.554688780403907]
[173,69283.075577024065,1109.1951957078384,173.20768894256014,935.98750676527823,68347.088070258789,47.552426656774628]
[174,68347.088070258789,1109.1951957078384,170.86772017564698,938.32747553219133,67408.760594726598,46.560805754053241]
[175,67408.760594726598,1109.1951957078384,168.52190148681649,940.67329422102193,66468.087300505576,45.57973107450325]
[176,66468.087300505576,1109.1951957078384,166.17021825126395,943.02497745657445,65525.062323049002,44.609108405893352]
[177,65525.062323049002,1109.1951957078384,163.81265580762249,945.38253990021587,64579.679783148786,43.648844315261286]
[178,64579.679783148786,1109.1951957078384,161.44919945787197,947.74599624996642,63631.933786898822,42.698846142726048]
[179,63631.933786898822,1109.1951957078384,159.07983446724705,950.11536124059126,62681.818425658232,41.759021995348078]
[180,62681.818425658232,1109.1951957078384,156.7045460641456,952.49064964369279,61729.327776014536,40.829280741037067]
[181,{"$f":"IF(F182>0,F182,0)","v":61729.327776014536},{"$f":"IF(B183>0,C182,0)","v":1109.1951957078384},{"$f":"B183*$J$1/1200","v":154.32331944003633},{"$f":"C183-D183","v":954.87187626780201},{"$f":"B183-E183","v":60774.455899746732},{"$f":"D183/POWER(1+9/1200,A183)","v":39.909532002506964}]
[182,60774.455899746732,1109.1951957078384,151.93613974936682,957.25905595847155,59817.196843788261,38.999686151278013]
[183,59817.196843788261,1109.1951957078384,149.54299210947065,959.65220359836769,58857.544640189895,38.09965430172516]
[184,58857.544640189895,1109.1951957078384,147.14386160047474,962.05133410736357,57895.493306082535,37.209348305172703]
[185,57895.493306082535,1109.1951957078384,144.73873326520635,964.45646244263207,56931.0368436399,36.328680744034806]
[186,56931.0368436399,1109.1951957078384,142.32759210909973,966.8676035987387,55964.169240041163,35.45756492600141]
[187,55964.169240041163,1109.1951957078384,139.91042310010289,969.28477260773548,54994.884467433425,34.595914878269376]
[188,54994.884467433425,1109.1951957078384,137.48721116858354,971.70798453925477,54023.176482894167,33.743645341818272]
[189,54023.176482894167,1109.1951957078384,135.05794120723542,974.13725450060292,53049.039228393565,32.900671765730699]
[190,53049.039228393565,1109.1951957078384,132.62259807098391,976.57259763685443,52072.466630756709,32.066910301556653]
[191,52072.466630756709,1109.1951957078384,130.18116657689177,979.0140291309466,51093.452601625766,31.242277797721727]
[192,51093.452601625766,1109.1951957078384,127.73363150406442,981.46156420377395,50111.991037421991,30.426691793978673]
[193,50111.991037421991,1109.1951957078384,125.27997759355499,983.91521811428333,49128.075819307705,29.620070515902022]
[194,49128.075819307705,1109.1951957078384,122.82018954826927,986.37500615956912,48141.700813148134,28.822332869425583]
[{"$f":"A196+1","v":195},48141.700813148134,1109.1951957078384,120.35425203287033,988.840943674968,47152.859869473163,28.033398435422313]
[196,47152.859869473163,1109.1951957078384,117.88214967368292,991.31304603415549,46161.546823439006,27.253187464326277]
[197,46161.546823439006,1109.1951957078384,115.40386705859751,993.79132864924088,45167.755494789766,26.481620870796416]
[198,45167.755494789766,1109.1951957078384,112.91938873697441,996.27580697086398,44171.479687818901,25.71862022842183]
[199,44171.479687818901,1109.1951957078384,110.42869921954724,998.76649648829107,43172.713191330608,24.964107764468142]
[200,43172.713191330608,1109.1951957078384,107.93178297832652,1001.2634127295119,42171.449778601098,24.218006354664762]
[201,42171.449778601098,1109.1951957078384,105.42862444650275,1003.7665712613356,41167.68320733976,23.480239518032622]
[202,41167.68320733976,1109.1951957078384,102.91920801834941,1006.2759876894889,40161.407219650268,22.750731411752149]
[203,40161.407219650268,1109.1951957078384,100.40351804912567,1008.7916776587127,39152.615541991552,22.029406826071188]
[204,39152.615541991552,1109.1951957078384,97.881538854978885,1011.3136568528595,38141.301885138695,21.316191179252474]
[205,38141.301885138695,1109.1951957078384,95.353254712846734,1013.8419409949917,37127.459944143702,20.611010512560373]
[206,37127.459944143702,1109.1951957078384,92.818649860359258,1016.3765458474791,36111.083398296221,19.913791485286698]
[207,36111.083398296221,1109.1951957078384,90.277708495740555,1018.9174872120979,35092.165911084121,19.22446136981522]
[208,35092.165911084121,1109.1951957078384,87.730414777710294,1021.4647809301281,34070.70113015399,18.542948046724476]
[209,34070.70113015399,1109.1951957078384,85.17675282538498,1024.0184428824534,33046.682687271539,17.869179999928825]
[210,33046.682687271539,1109.1951957078384,82.616706718178861,1026.5784889896595,32020.104198281879,17.203086311857213]
[211,32020.104198281879,1109.1951957078384,80.050260495704691,1029.1449352121338,30990.959263069744,16.544596658669533]
[212,30990.959263069744,1109.1951957078384,77.477398157674358,1031.7177975501641,29959.241465519579,15.893641305510188]
[213,29959.241465519579,1109.1951957078384,74.898103663798949,1034.2970920440393,28924.94437347554,15.250151101798625]
[214,28924.94437347554,1109.1951957078384,72.312360933688851,1036.8828347741496,27888.06153870139,14.614057476556511]
[215,27888.06153870139,1109.1951957078384,69.720153846753476,1039.4750418610849,26848.586496840304,13.985292433771361]
[216,26848.586496840304,1109.1951957078384,67.121466242100766,1042.0737294657376,25806.512767374566,13.363788547796194]
[217,25806.512767374566,1109.1951957078384,64.516281918436405,1044.678913789402,24761.833853585165,12.74947895878509]
[218,24761.833853585165,1109.1951957078384,61.904584633962912,1047.2906110738754,23714.543242511289,12.142297368164297]
[219,23714.543242511289,1109.1951957078384,59.286358106278229,1049.9088376015602,22664.634404909728,11.542178034138566]
[220,22664.634404909728,1109.1951957078384,56.66158601227432,1052.5336096955641,21612.100795214163,10.949055767232592]
[221,21612.100795214163,1109.1951957078384,54.030251988035403,1055.164943719803,20556.93585149436,10.362865925867142]
[222,20556.93585149436,1109.1951957078384,51.392339628735897,1057.8028560791024,19499.132995415257,9.7835444119696771]
[223,19499.132995415257,1109.1951957078384,48.747832488538137,1060.4473632193003,18438.685632195957,9.2110276666192021]
[224,18438.685632195957,1109.1951957078384,46.096714080489889,1063.0984816273485,17375.587150568608,8.6452526657250708]
[225,17375.587150568608,1109.1951957078384,43.438967876421522,1065.7562278314169,16309.830922737192,8.0861569157394566]
[226,16309.830922737192,1109.1951957078384,40.774577306842978,1068.4206184009954,15241.410304336197,7.5336784494033093]
[227,15241.410304336197,1109.1951957078384,38.10352576084049,1071.0916699469979,14170.318634389199,6.9877558215254583]
[228,14170.318634389199,1109.1951957078384,35.425796585972996,1073.7693991218653,13096.549235267334,6.4483281047946335]
[229,13096.549235267334,1109.1951957078384,32.741373088168338,1076.4538226196701,12020.095412647664,5.915334885624187]
[230,12020.095412647664,1109.1951957078384,30.050238531619161,1079.1449571762191,10940.950455471446,5.3887162600292164]
[231,10940.950455471446,1109.1951957078384,27.352376138678615,1081.8428195691597,9859.1076359022863,4.868412829535874]
[232,9859.1076359022863,1109.1951957078384,24.647769089755716,1084.5474266180827,8774.5602092842037,4.3543656971225877]
[233,8774.5602092842037,1109.1951957078384,21.936400523210512,1087.2587951846278,7687.3014140995756,3.8465164631929798]
[234,7687.3014140995756,1109.1951957078384,19.218253535248937,1089.9769421725894,6597.324471926986,3.3448072215802083]
[235,6597.324471926986,1109.1951957078384,16.493311179817464,1092.7018845280209,5504.6225873989652,2.8491805555825249]
[236,5504.6225873989652,1109.1951957078384,13.761556468497414,1095.4336392393409,4409.1889481596245,2.3595795340297667]
[237,4409.1889481596245,1109.1951957078384,11.022972370399062,1098.1722233374394,3311.0167248221851,1.8759477073805872]
[238,3311.0167248221851,1109.1951957078384,8.277541812055464,1100.9176538957829,2210.0990709264024,1.3982291038501626]
[239,{"$f":"IF(F240>0,F240,0)","v":2210.0990709264024},{"$f":"IF(B241>0,C240,0)","v":1109.1951957078384},{"$f":"B241*$J$1/1200","v":5.5252476773160062},{"$f":"C241-D241","v":1103.6699480305224},{"$f":"B241-E241","v":1106.42912289588},{"$f":"D241/POWER(1+9/1200,A241)","v":0.92636822556815157}]
[240,1106.42912289588,1109.1951957078384,2.7660728072397003,1106.4291229005987,-4.7186858864733949E-9,0.46031004476666904]
[null,null,{"$f":"SUM(C3:C242)","v":266206.84696988191},{"$f":"SUM(D3:D242)","v":66206.84696987654},200000.00000000471]

{"sheet":"Sheet1","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Please enable macros"]